SELECT MANDT,SEQNO,ZCLASSIFIER,ZCODE,NAME1,PSTLZ,LAND1,TELF1,TELF2,TELFX,SMTP_ADDR,STCD2,J_1KFREPRE,ERDAT,AEDAT,LOEVM,TDATE,CDATE,IFFLG,ERTXT,
ADDR,ADDR2,ADDR3,ADDR4,ADDR5,STRAS,ORT01,CNAME,CPHON,BNAME,BPHON,C00101,C00102,C00103,C00104,C00105,N00101,N00102,WERKS,STATUS
FROM
CUSTOMER_V
where ZCODE NOT LIKE '2%'